[Company Name] Web Site Budgeting Tool
[Date]
Gray cells contain calculations that should not be altered.
Company Data Required rate of return Tax rate 10.0% 30.0%
0 Initial Investment in Web Site Hardware (e.g., servers) Software (e.g., e-commerce catalog software) Development (e.g., third-party site design and development) Total Initial Investments $25,000 15,000 150,000 $190,000
Benefits from Web Site Direct sales Incremental sales resulting from enhanced promotional/salesperson effectiveness Incremental sales resulting from increased partner participation Reduced travel costs Reduced customer service costs Reduced printing and shipping costs [Other benefits] [Other benefits] [Other benefits] Total Benefits
Costs (Excluding Initial Capital Investments) Cost of sales Maintenance Project management, customer support Online advertising, search-engine registration Depreciation on capital expenditures (calculation uses three-year period) Hosting, domain-name registration General and administrative (e.g., rent, insurance, exec. salaries) [Other costs] [Other costs]
[Other costs] Total Costs Net Benefits (Costs) Tax Value after tax Depreciation added back Cash flow Cumulative cash flow Evaluation Metrics Net present value (NPV) Internal rate of return (IRR) Payback period (in years)
($190,000) ($190,000)
$394 10.1% 2.52
YEAR 1 2 3
$15,000 25,000 25,000 25,000 50,000 5,000 0 0 0 $145,000
$50,000 25,000 25,000 25,000 50,000 5,000 0 0 0 $180,000
$75,000 25,000 25,000 25,000 50,000 5,000 0 0 0 $205,000
$7,500 15,000 35,000 10,000 63,333 150 10,000 0 0
$25,000 15,000 35,000 10,000 63,333 150 10,000 0 0
$37,500 15,000 35,000 10,000 63,333 150 10,000 0 0
0 $140,983 $4,017 1,205 2,812 63,333 $66,145 ($123,855)
0 $158,483 $21,517 6,455 15,062 63,333 $78,395 ($45,460)
0 $170,983 $34,017 10,205 23,812 63,333 $87,145 $41,685